<html xmlns:th="http://www.thymeleaf.org">
<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Title</title>
  <style>
    a{
      margin: 12px;
      font-size: 26px;
    }
  </style>
</head>
<body style="   ">



<pre  style="font-size: 33px;  ">
      @GetMapping(value = "/test")
        System.out.println("访问 TEST 页面...");
        return "test.html";

    @GetMapping(value = "/api/test/buy")
    @ResponseBody
    public String ResponseBody_test()
</pre>


<img th:src="@{/img/TEST.jpg}" style="width:123px; height:123px;  " />



<h1>首页  index  (  记得新建数据库  ) </h1>

<div style="">
<!--  <a target="_blank" th:href="@{/database}"> 查看数据库 url </a>-->
<!--  <a target="_blank" th:href="@{/select/config}"> 查看配置文件 application.properties </a>-->
<!--  <h2>数据库测试:</h2>-->
<!--  <a target="_blank" th:href="@{/select/show_databases}">1-show databases (测试数据库链接是否成功)</a>-->
</div>

<h2>插入一些测试数据, 测试数据库中文和 emoji 是否乱码 </h2>

<pre style="font-size: 24px;">
-- MySQL 8 默认编码  utf8mb4
CREATE DATABASE IF NOT EXISTS `db_emoji_test` DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
use `db_emoji_test`;

CREATE TABLE IF NOT EXISTS `tb_user`(
`id` int(50) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`name`  varchar(200)  ,
`age`   int(20)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO tb_user(`name` , `age`) VALUES (  '张三' ,  23);
INSERT INTO tb_user(`name` , `age`) VALUES (  '凯奇' ,  66);
INSERT INTO tb_user(`name` , `age`) VALUES (  '张洁' ,  35);
INSERT INTO tb_user(`name` , `age`) VALUES (  '汤姆🥵👿👻💀' ,  45);
INSERT INTO tb_user(`name` , `age`) VALUES (  '杰克😅😎🥶🤡🤖🤟👈' ,  56);
select * from tb_user;
</pre>


<br><br><br><br><br><br><br><br><br>
</body>
<script th:inline="javascript">
</script>
</html>